• File: prodid_info.php
  • Full Path: C:/htdocs/reeft_gps_test/REEFTintegrationLog/saved/prodid_info.php
  • Date Modified: 04/30/2025 7:56 AM
  • File size: 24.16 KB
  • MIME-type: text/x-php
  • Charset: utf-8
<?php
//======================================================================================
//
// Function: Show prodid info
//
// Programmer: JJ
// Date      : 2022-03-07
//
// Copyright Reeft A/S (c) - 2022
//=======================================================================================

//======================================================================================
// General config
//======================================================================================
	include "config/config.php";

//======================================================================================
// Input
//======================================================================================
	if (isset($_REQUEST["reference"])) $input_reference = $_REQUEST["reference"];
	else {
		$input_reference = '';
	}

	if (isset($_REQUEST["prodid"])) $input_prodid = $_REQUEST["prodid"];
	else {
		$input_prodid = '';
	}

	if (isset($_REQUEST["wc"])) $input_wc = $_REQUEST["wc"];
	else {
		$input_wc = '';
	}

	if (isset($_REQUEST["ref_wc"])) $input_ref_wc = $_REQUEST["ref_wc"];
	else {
		$input_ref_wc = '';
	}

	if (isset($_REQUEST["show_header"])) $input_show_header = $_REQUEST["show_header"];
	else {
		$input_show_header = 'N';
	}

//======================================================================================	
// Set line
//======================================================================================	

	if ( $input_reference == 'Line1') 		$line = 'LA';
	if ( $input_reference == 'Line2') 		$line = 'LB';
	if ( $input_reference == 'Line3') 		$line = 'LC';
	if ( $input_reference == 'Line4') 		$line = 'LD';
	if ( $input_reference == 'Line5') 		$line = 'LE';
	if ( $input_reference == 'Line11') 		$line = 'LK';
	if ( $input_reference == 'Testline')	$line = 'LK';

//======================================================================================
// Global
//======================================================================================

	include "include/global_data.php";
	
//======================================================================================
// Get language file
//======================================================================================

	if ( $input_reference == 'Line1' ) {
		include "language/swe_line1.php";
	}
	if ( $input_reference == 'Line2' ) {
		include "language/swe_line2.php";
	}
	if ( $input_reference == 'Line3' ) {
		include "language/swe_line3.php";
	}
	if ( $input_reference == 'Line4' ) {
		include "language/swe_line4.php";
	}
	if ( $input_reference == 'Line5' ) {
		include "language/swe_line5.php";
	}
	if ( $input_reference == 'Line11' ) {
		include "language/swe_line11.php";
	}
	if ( $input_reference == 'Testline' ) {
		include "language/swe_line2.php";
	}
	
	// print_r($locale_text);
	
//======================================================================================
// Set language
//======================================================================================

	include "include/set_language.php";
	

//======================================================================================
// Input
//======================================================================================
	$reference = $global_reference1;
	$machine = $global_reference1;
	
//======================================================================================
// Connect to link script
//======================================================================================
	//include "include/web-connect.php";


//======================================================================================
?>
<!DOCTYPE html>
<html lang="en">
<head>
	<title>REEFTvisual - Prod Id info</title>

    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <!--<meta name="viewport" content="width=device-width, initial-scale=1">-->
	<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">

    <meta name="description" content="REEFTvisual - Stoptime">
    <meta name="author" content="Jan Jorgensen, REEFT A/S">
    <link rel="icon" href="images/favicon/favicon.ico">	

    <!-- Bootstrap core CSS -->
    <link href="css/bootstrap4.3.1/css/bootstrap.custom.min.css" rel="stylesheet">
	<link href="css/bootstrap4.3.1/css/normalize.css" rel="stylesheet" type="text/css">

	<script src="css/fontawesome6.5.1/js/all.min.js"></script>	
	<script src="css/fontawesome6.5.1/js/sharp-light.min.js"></script>
	<script src="css/fontawesome6.5.1/js/sharp-regular.min.js"></script>
	<script src="css/fontawesome6.5.1/js/sharp-solid.min.js"></script>
	<script src="css/fontawesome6.5.1/js/sharp-thin.min.js"></script>
	

    <!-- Custom styles for this template -->
    <link href="css/custom.css" rel="stylesheet">

    <script src="javascript/jquery.js"></script>

    <script src="css/bootstrap4.3.1/js/popper.js"></script>
    <script src="css/bootstrap4.3.1/js/bootstrap.min.js"></script>
	
	<link href="javascript/daatatables/media/css/jquery.dataTables.min.css" rel="stylesheet" type="text/css">
	<link href="javascript/daatatables/media/css/fixedHeader.dataTables.min.css" rel="stylesheet" type="text/css">
	<link href="javascript/daatatables/Buttons-1.4.2/css/buttons.dataTables.min.css" rel="stylesheet" type="text/css">

    <script src="javascript/daatatables/media/js/jquery.dataTables.min.js"></script>
    <script src="javascript/daatatables/media/js/dataTables.fixedHeader.min.js"></script>
	<script src="javascript/daatatables/Buttons-1.4.2/js/dataTables.buttons.min.js"></script>
	<script src="javascript/daatatables/Buttons-1.4.2/js/buttons.flash.min.js"></script>
	<script src="javascript/daatatables/JSZip-2.5.0/jszip.min.js"></script>
	<script src="javascript/daatatables/pdfmake-0.1.53/pdfmake.min.js"></script>
	<script src="javascript/daatatables/pdfmake-0.1.53/vfs_fonts.js"></script>
	<script src="javascript/daatatables/Buttons-1.4.2/js/buttons.html5.min.js"></script>
	<script src="javascript/daatatables/Buttons-1.4.2/js/buttons.print.min.js"></script>

    <script type="text/javascript" src="javascript/jquery.ui.touch-punch.min.js"></script>
	<script src="javascript/jquery.scrollTo.min.js"></script>		

	<script type="text/javascript" src="javascript/moment.min.js"></script>
	
	<script src="javascript/shortcut.js"></script>	
	
<style>	

.sticky {
  position: fixed;
  top: 0;
  height:200px;
  width: 100%
}


</style>	


<script>
<!--

//=============================================================================
// Globals
//=============================================================================
	
	// Show header 
	var DFT_SHOW_HEADER = '<?php echo $input_show_header ?>';
	
	var saveProdID = '';
	
	
	$(function () {
             var $win = $(window);

             $win.scroll(function () {
                 if ($win.scrollTop() == 0) {
				    $().stop(); 
                     //alert('Scrolled to Page Top');
				 }
				 else if ($win.height() + $win.scrollTop() >= $(document).height()) {
				    $().stop() ;
                    //alert('Scrolled to Page Bottom');
                 }
             });
         });	

//=============================================================================
// Get data for a line
//=============================================================================
function getData()
{

		$('#data-area').html( '<div class="text-center"><h3>Working, please wait...</h3></div>' );

		//var prodid = '<?php echo $input_prodid ?>';
		var reference = '<?php echo $input_reference ?>';
		
		var prodid = $('#current-prodid').val();		

		parmData = 'reference=' + reference
				 + '&prodid=' + prodid
				 ;
				 

		$.ajax({
			type: "GET",
			url: 'proxy-cg9959.php',
			data: parmData,
			dataType: "xml",
			cache: false,
			success: function( xml ) {

				HTMLstring ='<table id="REEFT-data" class="table table-bordered table-hover">';

				HTMLstring +='<thead>'
						   + '<tr>'
						   + '<td colspan="11">'
						   + '<button type="button" title="Alt+1" style="width:150px" id="window-scroll-down-button" class="btn btn-primary mb-1 mr-2" onclick="scrollToSomething(\'*down\')">Down</button>'
						   + '<button type="button" title="Alt+2" style="width:150px" id="window-scroll-up-button" class="btn btn-primary mb-1 mr-2" onclick="scrollToSomething(\'*up\')">Up</button>'
						   + '<button type="button" title="Alt+3" style="width:150px" id="window-scroll-top-button" class="btn btn-primary mb-1 mr-2" onclick="scrollToSomething(\'*top\')">Top</button>'
						   + '<button type="button" title="Alt+4" style="width:150px" id="window-scroll-bottom-button" class="btn btn-primary mb-1 mr-4" onclick="scrollToSomething(\'*end\')">Bottom</button>'
						   + '<button type="button" style="width:150px" id="window-close-button" class="btn btn-danger mb-1 mr-2" onclick="window.close()">Close</button>'
						   + '</td>'
						   + '<td>'
						   + '<span class="h3 font-weight-bold"><?php echo "$line - $input_wc" ?></span>'
						   + '</td>'
						   + '</tr>' 
				           + '<tr class="bg-primary text-white">'
						   //+ '<th class="" title="">' + 'No' + '</th>'
						   //+ '<th class="" data-toggle="popover" data-trigger="focus" data-placement="right" title="WAMML963/WXMOD" data-content="WAMML963/WXMOD">' + 'Model' + '</th>'
						   + '<th class="" title="WAMML963/WXMNR">' + 'Machine' + '</th>'
						   + '<th class="" title="WAMML963/WXPNC">' + 'PNC' + '</th>'
						   + '<th class="" title="MSPMP100/DESCP">' + 'Description' + '</th>'
						   + '<th class="" title="MSPMP10X/M1UPP">' + 'Heating' + '</th>'
						   + '<th class="" title="MSPMP10X/M3FAS">' + 'Phase' + '</th>'
						   + '<th class="" title="MSPMP10X/M3WGH">' + 'Weighing System' + '</th>'
						   + '<th class="" title="MSPMP10X/M1MDB">' + 'Model-external' + '</th>'
						   + '<th class="" title="MSPMP10X/M3TYP">' + 'Approval Type' + '</th>'
						   + '<th class="" title="MSPMP10X/M3DRN">' + 'Drain' + '</th>'
						   + '<th class="" title="MSPMP10X/W1SPE">' + 'Transformer' + '</th>'
						   + '<th class="" title="MSPMP10X/W1SPE">' + 'Status' + '</th>'
						   + '<th class="" title="">' + '' + '</th>'
						   //+ '<th class="" title="">' + 'Station' + '</th>'
						   + '</tr>'
						   + '</thead>'
						   + '<tbody>'
						   ;
						   
				c = 0;
						   

				$(xml).find('detail').each(function () {

					var counter 		= $(this).find('counter').text();
					var machine_pretty 	= $(this).find('machine_pretty').text();
					var wxrec 			= $(this).find('wxrec').text();
					var wxmod 			= $(this).find('wxmod').text();
					var wxmnr 			= $(this).find('wxmnr').text();
					var wxpnc 			= $(this).find('wxpnc').text();
					var m1upp 			= $(this).find('m1upp').text();
					var m3fas 			= $(this).find('m3fas').text();
					var m3wgh 			= $(this).find('m3wgh').text();
					var m1mdb 			= $(this).find('m1mdb').text();
					var m3typ 			= $(this).find('m3typ').text();
					var m3drn 			= $(this).find('m3drn').text();
					var w1spe 			= $(this).find('w1spe').text();
					var descp 			= $(this).find('descp_1').text();
					var descp 			= $(this).find('descp').text();
					var date     		= $(this).find('date').text();
					var time     		= $(this).find('time').text();
					var direction 		= $(this).find('direction').text();

					// Set previous update
					$('#prev-update').html(date + ' / ' + time);

					if ( direction == '*active') {
						counter = 0;
						var markClass = 'font-weight-bold bg-success text-white';
						var direction = '<?php echo $input_wc ?>';
					} else {
						var markClass = '';
					}
					
					var wcID = 'wcID-' + c;
					c++;
					var wcID = 'WC' + c + '_TEXT';
					var wcID = '';
					
					if ( direction == '*done' ) 
					{
						direction_text = '<span title="Done"><i style="font-size:1.4em" class="fa-regular fa-check"></i></span>';
					} 
					else if ( direction == '*new' ) 
					{
						direction_text = '<span title="New"><i  class="fa-regular fa-washing-machine" style="font-size:1.4em"></i></span>';
					} else {
						direction_text = direction;
					}

					// Create button
					var myButton_01 = '<button onclick="showProdidFlow(' 
									+ '\''
									+ '<?php echo $line ?>'
									+ '\''
									+ ','
									+ '\''
									+ machine_pretty
									+ '\''
									+ ')" class="btn btn-primary">' 
									+ 'Prodid flow'
									+ '</button>'
									;
					

					HTMLstring +='<tr class="' + markClass + '">'
							   //+ '<td><div class=" text-center">' + counter 	+ '</div></td>'
							   //+ '<td><div class="text-center">' + wxmod + '</div></td>'
							   + '<td data-sort="' + wxrec + '"><div class="text-center">' + wxmnr + '</div></td>'
							   + '<td><div class="">' + wxpnc + '</div></td>'
							   + '<td><div class="">' + descp + '</div></td>'
							   + '<td><div class="text-center">' + m1upp + '</div></td>'
							   + '<td><div class="text-center">' + m3fas + '</div></td>'
							   + '<td><div class="text-center">' + m3wgh + '</div></td>'
							   + '<td><div class="text-center">' + m1mdb + '</div></td>'
							   + '<td><div class="text-center">' + m3typ + '</div></td>'
							   + '<td><div class="text-center">' + m3drn + '</div></td>'
							   + '<td><div class="text-center">' + w1spe + '</div></td>'
							   + '<td><div class="text-center">' + direction_text + '</div></td>'
							   + '<td><div class="text-center">' + myButton_01 + '</div></td>'
							   //+ '<td><div><span  class="wc-name-class" id="'+ wcID + '">' + wcID + ' ' + direction + '</span></div></td>'
							   + '</tr>'
							   ;

				});

				HTMLstring += '</tbody>'
						   +  '</table>';

				$('#data-area').html( HTMLstring );
				
				setDataTables();

			},
			complete:function () {
				
				
				// $('.wc-name-class').each(function(i, obj) {
					
					// var id = obj.id;
					// var id = 
					
					// console.log(i + ' ' + id + '........')
					// //console.log(obj)
					
					// //$(this.id).html('<?php echo $locale_text["WC1_TEXT"] ?>' + ' ' + i)
					// $('#' + id).html( i )
					// // if ( i == 5 ) $('#WC1_TEXT').html('<?php echo $locale_text["WC1_TEXT"] ?>' + ' ' + i)
					// // if ( i == 4 ) $('#WC2_TEXT').html('<?php echo $locale_text["WC2_TEXT"] ?>' + ' ' + i)
					// // if ( i == 3 ) $('#WC2_TEXT').html('<?php echo $locale_text["WC3_TEXT"] ?>' + ' ' + i)
					
					
					
					
				// });				
				


			},
			error:function (xhr, ajaxOptions, thrownError){

			}

			});

}

//=============================================================================
// Set datatables
//=============================================================================
function setDataTables()
{
	
	if ( DFT_SHOW_HEADER == 'Y' ) {
		myDOM = 'lfi<bottom>Bp<"clear">';
	} else {
		myDOM = '';
	}

    $('#REEFT-data').DataTable({
        "responsive": true,
		"fixedHeader": true,
		"lengthMenu": [[10, 25, 50, 100, -1], [10, 25, 50, 100, "All"]],
		"iDisplayLength": -1,
        "processing": true,
		"dom": myDOM,
        "order": [[ 0, "asc" ]],
		"columnDefs": [
				{
				"targets": [ 10,11 ],
				"visible": true,
				"searchable": false,
				 "orderable": false
				},
		],
		"language":
		{

					"sProcessing":   "<?php echo $datahub_datatable_Processing ?>",
					"sLengthMenu":   "<?php echo $datahub_datatable_LengthMenu ?>",
					"sZeroRecords":  "<?php echo $datahub_datatable_ZeroRecords ?>",
					"sInfo":         "<?php echo $datahub_datatable_Info ?>",
					"sInfoEmpty":    "<?php echo $datahub_datatable_InfoEmpty ?>",
					"sInfoFiltered": "<?php echo $datahub_datatable_InfoFiltered ?>",
					"sInfoPostFix":  "<?php echo $datahub_datatable_InfoPostFix ?>",
					"sLoadingRecords": "<?php echo $datahub_datatable_Processing ?>",
					"sSearch":       "<?php echo $datahub_datatable_Search ?>",
					"sUrl":          "<?php echo $datahub_datatable_Url ?>",
					"oPaginate": {
						"sFirst":    "<?php echo $datahub_datatable_First ?>",
						"sPrevious": "<?php echo $datahub_datatable_Previous ?>",
						"sNext":     "<?php echo $datahub_datatable_Next ?>",
						"sLast":     "<?php echo $datahub_datatable_Last ?>"
					}
		},
        "rowCallback": function(row, data, index)
		{



		},
        "preDrawCallback": function(settings)
		{
		},
		"initComplete": function ()
		{

		},
		"buttons": 	[
					{
						extend: 'pdf',
						text: '<img src="images/pdf_logo.png" height="25"> PDF',
						orientation: 'landscape',
						exportOptions: {
						modifier: {
							page: 'all'
							}
						}
					},
					{
						extend: 'excel',
						text: '<img src="images/microsoft_excel_logo.png" height="25"> Excel'
						},
						{
						extend: 'copy',
						text: '<img src="images/copy.png" height="25"> Copy to Clipboard'
						},
					]
    });
	
}


//=============================================================================
// Get prodid for a line
//=============================================================================
function getProdID()
{

		// console.clear();
		// console.log('GET PRODID');

		var reference = '<?php echo $input_reference ?>';

		parmData = 'reference=' + reference
				 ;


		$.ajax({
			type: "GET",
			url: 'getprodid_json.php',
			data: parmData,
			dataType: "json",
			cache: false,
			success: function( jsonData ) {
				
				$.each( jsonData.detail, function( index, object ){

					var wcName			= object.wcName;				
					var prodid_raw		= object.prodid_raw;				
					var prodid_pretty	= object.prodid_pretty;				
					var key				= object.key;				
					var ProdIDstatus	= object.ProdIDstatus;				
					
					//console.log(wcName + ' ' + prodid_pretty);
				
					if ( wcName == '<?php echo $input_ref_wc ?>' ) {
						$('#current-prodid').val( prodid_pretty );
						
							if ( saveProdID != prodid_pretty ) {
								$('#current-prodid-status').val( 'NEW' );
								getData();
							} else {
								$('#current-prodid-status').val( 'SAME' );
							}
						
						saveProdID = prodid_pretty;
					}
					
					
					
				});					


			},
			complete:function () {


			},
			error:function (xhr, ajaxOptions, thrownError){

			}

			});

}

//=============================================================================
// Scroll to something
//=============================================================================
function scrollToSomething( action ) 
{

	if ( action == '*down') {
		$.scrollTo('+=350px', 1000);
	}
	
	if ( action == '*up') {
		$.scrollTo('-=350px', 1000);
	}
	
	if ( action == '*top') {
		$.scrollTo(0, 1000);
	}
	
	if ( action == '*end') {
		$.scrollTo('max', 1000);
	}
	

}

//=============================================================================
// Get data for a line
//=============================================================================
function showProdidFlow( lilin, prodid )
{

	// Split prodid
	var ary_ProdID = prodid.split('-');	
	
	let prodid_1 = ary_ProdID[0].trim();
	let prodid_2 = ary_ProdID[1].trim();
	let prodid_3 = ary_ProdID[2].trim();

	var url = 'hub_wa0358_maintain.php'
			+ '?lilin=' 	+ lilin
			+ '&prodid_1=' 	+ prodid_1
			+ '&prodid_2=' 	+ prodid_2
			+ '&prodid_3=' 	+ prodid_3
			
	popUpCenter(url, '', '', '');

}

//=============================================================================
// screen popup - center
//=============================================================================
function popUpCenter(url, p1, p2, p3)
{

	var v1_w  = screen.availWidth;
	var v1_h  = screen.availHeight;

	if ( parseInt(v1_w) > 1800 ) {
		v1_w = 1800;
		v1_h = v1_h - 200;
		v1_center = v1_w/0.8;
	}

	// Center popup as good as possible
	var left = (screen.width - v1_w) / 2;
	var top = (screen.height - v1_h) / 4;

	var winname = 'win_' + url;

	params  = 'width='+v1_w;
	params += ', height='+v1_h;
	params += ', top=' + top + ', left=' + left;
	params += ', fullscreen=yes';
	params += ',scrollbars=1';

	overview_win = window.open(url,winname, params);
	if (window.focus) {overview_win.focus()}
	return false;

}

//=============================================================================
// screen popup - center - bigger
//=============================================================================
function popUpCenterBig(url, p1, p2, p3)
{

	var v1_w  = screen.availWidth;
	var v1_h  = screen.availHeight;

	// Get 25%
	v1_w_pct = v1_w * 0.25;

	v1_w_new = v1_w - v1_w_pct;


	if ( v1_w_new < 1 ) {
		v1_w_new	= 1800;
	}

	v1_w = v1_w_new;
	v1_h = v1_h - 200;
	v1_center = v1_w/0.8;

	// Center popup as good as possible
	var left = (screen.width - v1_w) / 2;
	var top = (screen.height - v1_h) / 4;

	var winname = 'win_' + url;

	params  = 'width='+v1_w;
	params += ', height='+v1_h;
	params += ', top=' + top + ', left=' + left;
	params += ', fullscreen=yes';
	params += ',scrollbars=1';

	overview_win = window.open(url,winname, params);
	if (window.focus) {overview_win.focus()}
	return false;

}

//=============================================================================
// Clear messge
//=============================================================================
function clearMessage( )
{

	$('#message').html( '' );

}

//=============================================================================
// Set clock
//=============================================================================
function updateClock() {

  $('#current-time').html(moment().format('YYYY-MM-DD HH:mm:ss'));

}

//=============================================================================
// jQuery - Ready
//=============================================================================
$(document).ready(function() {

	//-----------------------------------------------------------------------
	// Start the clock
	//-----------------------------------------------------------------------
		updateClock();
		setInterval(function() {
			updateClock();
		}, 1000); 
	//-----------------------------------------------------------------------
	
	// Reset
	$('#current-prodid').val('<?php echo $input_prodid ?>');

	// Get data
	//getData();
	getProdID();
	
	setInterval(function(){ 
		//getProdID();
	}, 10000);		
	
	
	if ( DFT_SHOW_HEADER == 'Y' ) {
		$('.header-class').removeClass('d-none');
	}
	

	// Make pop over avaiable all over the page
	$(function () {
		$('[data-toggle="popover"]').popover()
	})


	//=======================================================================
	// Set shortcut keys
	//=======================================================================

	// Toggle show deleted
	shortcut.add("ESCAPE",function() {
		$('#window-close-button').click();
	});

	// Scroll down
	shortcut.add("Alt+1",function() {
		$('#window-scroll-down-button').click();
	});
	
	// Scroll up
	shortcut.add("alt+2",function() {
		$('#window-scroll-up-button').click();
	});

	// Scroll bottom
	shortcut.add("alt+4",function() {
		$('#window-scroll-bottom-button').click();
	});

	// Scroll top
	shortcut.add("alt+3",function() {
		$('#window-scroll-top-button').click();
	});




});

// -->
</script>

</head>

<body>

<div id="overview-data" class="container-fluid mb-4">

<input class="d-none" id="current-prodid" size="40">
<input class="d-none" id="current-prodid-status">


	<div class="row header-class d-none">
	
		<div class="col">
			<span class="xd-none"><a href="javascript:void(0)"><img src="images/customer-logo.png" border="0" align="bottom" alt="REEFT A/S did this..."></a></span>
		</div>

		<div class="col text-center h3">
			<i class="font-awesome-pseudo-class fa-thin fa-clock"></i>&nbsp;&nbsp;<span id="current-time"></span>
			<div class="font-weight-bold mt-2">Prod ID list</div>
		</div>
		
		<div class="col text-right">
			<span class="xd-none"><a href="javascript:void(0)"><img src="images/reeft_logo.png" border="0" align="bottom"></a></span>
		</div>
	</div>

	<div class="row mt-2">
		<div class="col-12">
			<div id="data-area"></div>
		</div>
	</div>

<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>

</div>

</body>
</html>